[]
        
(Showing Draft Content)

FarPoint.Win.Spread.SheetView.SetConditionalFormatting

SetConditionalFormatting Method

SetConditionalFormatting(int, int, params IConditionalFormattingRule[])

Sets conditional formatting for a specified cell on the sheet based on specified rules.

Declaration
public void SetConditionalFormatting(int row, int column, params IConditionalFormattingRule[] rules)
Public Sub SetConditionalFormatting(row As Integer, column As Integer, ParamArray rules As IConditionalFormattingRule())
Parameters
Type Name Description
int row

Row index

int column

Column index

IConditionalFormattingRule[] rules

Rules to apply for the specified cell

SetConditionalFormatting(int, int, bool, params IConditionalFormattingRule[])

Sets conditional formatting for a specified cell on the sheet based on specified rules.

Declaration
public void SetConditionalFormatting(int row, int column, bool isCombinable, params IConditionalFormattingRule[] rules)
Public Sub SetConditionalFormatting(row As Integer, column As Integer, isCombinable As Boolean, ParamArray rules As IConditionalFormattingRule())
Parameters
Type Name Description
int row

Row index

int column

Column index

bool isCombinable

Indicates that rule(s) can be merged into an existing conditional format if they affect the same cell range(s).

IConditionalFormattingRule[] rules

Rules to apply for the specified cell

SetConditionalFormatting(int, int, int, int, params IConditionalFormattingRule[])

Sets conditional formatting for a specified range of cells on the sheet based on specified rules.

Declaration
public void SetConditionalFormatting(int row, int column, int rowCount, int columnCount, params IConditionalFormattingRule[] rules)
Public Sub SetConditionalFormatting(row As Integer, column As Integer, rowCount As Integer, columnCount As Integer, ParamArray rules As IConditionalFormattingRule())
Parameters
Type Name Description
int row

Starting row index

int column

Starting column index

int rowCount

Number of rows

int columnCount

Number of columns

IConditionalFormattingRule[] rules

Rules to apply for the specified range of cells

SetConditionalFormatting(int, int, int, int, bool, params IConditionalFormattingRule[])

Sets conditional formatting for a specified range of cells on the sheet based on specified rules.

Declaration
public void SetConditionalFormatting(int row, int column, int rowCount, int columnCount, bool isCombinable, params IConditionalFormattingRule[] rules)
Public Sub SetConditionalFormatting(row As Integer, column As Integer, rowCount As Integer, columnCount As Integer, isCombinable As Boolean, ParamArray rules As IConditionalFormattingRule())
Parameters
Type Name Description
int row

Starting row index

int column

Starting column index

int rowCount

Number of rows

int columnCount

Number of columns

bool isCombinable

Indicates that rule(s) can be merged into an existing conditional format if they affect the same cell range(s).

IConditionalFormattingRule[] rules

Rules to apply for the specified range of cells

SetConditionalFormatting(CellRange[], params IConditionalFormattingRule[])

Sets conditional formatting for a specified ranges of cells on the sheet based on specified rules.

Declaration
public void SetConditionalFormatting(CellRange[] cellRanges, params IConditionalFormattingRule[] rules)
Public Sub SetConditionalFormatting(cellRanges As CellRange(), ParamArray rules As IConditionalFormattingRule())
Parameters
Type Name Description
CellRange[] cellRanges

Cell ranges

IConditionalFormattingRule[] rules

Rules to apply for the specified range of cells

SetConditionalFormatting(CellRange[], bool, params IConditionalFormattingRule[])

Sets conditional formatting for a specified ranges of cells on the sheet based on specified rules.

Declaration
public void SetConditionalFormatting(CellRange[] cellRanges, bool isCombinable, params IConditionalFormattingRule[] rules)
Public Sub SetConditionalFormatting(cellRanges As CellRange(), isCombinable As Boolean, ParamArray rules As IConditionalFormattingRule())
Parameters
Type Name Description
CellRange[] cellRanges

Cell ranges

bool isCombinable

Indicates that rule(s) can be merged into existing conditional formatting if they affect the same cell range(s).

IConditionalFormattingRule[] rules

Rules to apply for the specified range of cells

SetConditionalFormatting(params ConditionalFormatting[])

Sets conditional formatting for the sheet.

Declaration
public void SetConditionalFormatting(params ConditionalFormatting[] cfs)
Public Sub SetConditionalFormatting(ParamArray cfs As ConditionalFormatting())
Parameters
Type Name Description
ConditionalFormatting[] cfs

Conditional formatting